Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6657

Need to document the fact that views can't be the source data sets of MERGE statements

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.11.1.1
    • 10.11.1.1
    • Documentation
    • None
    • Normal

    Description

      The work on DERBY-6652 now prevents views from being used as the source data sets of MERGE statements. We should adjust the Reference Guide section on the MERGE statement accordingly. This statement in rrefsqljmerge.dita:

      "sourceTable must identify a base table, a view, or a table function, and it may not be a synonym"

      should be changed to

      "sourceTable must identify a base table or a table function, and it may not be a synonym"

      Attachments

        1. DERBY-6657.diff
          0.8 kB
          Camilla Haase
        2. rrefsqljmerge.html
          13 kB
          Camilla Haase

        Issue Links

          Activity

            People

              chaase3 Camilla Haase
              rhillegas Richard N. Hillegas
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: